WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_tax_rate_locations' doesn't exist] SELECT tax_rate_id, location_code FROM wp_woocommerce_tax_rate_locations WHERE location_type = 'postcode' AND location_code LIKE '%...%';
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_tax_rates' doesn't exist]
SELECT tax_rates.*, COUNT( locations.location_id ) as postcode_count, COUNT( locations2.location_id ) as city_count
FROM wp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE 1=1 AND tax_rate_country IN ( 'US', '' ) AND tax_rate_state IN ( 'MN', '' ) AND tax_rate_class = '' AND ( ( locations.location_type IS NULL ) OR (
locations.location_type = 'postcode' AND locations.location_code IN ('','*')
AND (
( locations2.location_type = 'city' AND locations2.location_code = '' )
OR NOT EXISTS (
SELECT sub.tax_rate_id FROM wp_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'city'
AND sub.tax_rate_id = tax_rates.tax_rate_id
)
)
) OR (
locations.location_type = 'city' AND locations.location_code = ''
AND NOT EXISTS (
SELECT sub.tax_rate_id FROM wp_woocommerce_tax_rate_locations as sub
WHERE sub.location_type = 'postcode'
AND sub.tax_rate_id = tax_rates.tax_rate_id
)
) )
GROUP BY tax_rates.tax_rate_id
ORDER BY tax_rates.tax_rate_priority
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zone_locations' doesn't exist] SELECT zone_id, location_code FROM wp_woocommerce_shipping_zone_locations WHERE location_type = 'postcode';
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zones' doesn't exist] SELECT zones.zone_id FROM wp_woocommerce_shipping_zones as zones
LEFT OUTER JOIN wp_woocommerce_shipping_zone_locations as locations ON zones.zone_id = locations.zone_id AND location_type != 'postcode'
WHERE ( ( location_type = 'country' AND location_code = 'US' ) OR ( location_type = 'state' AND location_code = 'US:MN' ) OR ( location_type = 'continent' AND location_code = 'NA' ) OR ( location_type IS NULL ) ) ORDER BY zone_order ASC, zones.zone_id ASC LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zone_locations' doesn't exist] SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zone_methods' doesn't exist] SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0 AND is_enabled = 1
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zones' doesn't exist] SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zone_locations' doesn't exist] SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0
WordPress database error: [Table 'ykbsawjebk.wp_woocommerce_shipping_zone_methods' doesn't exist] SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0 AND is_enabled = 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable_hierarchy' doesn't exist] DELETE FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0'
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '1600' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '1600' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '1600' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '1600' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '1600' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '1600' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '2504' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT * FROM `wp_yoast_indexable` WHERE `object_id` = '2504' AND `object_type` = 'user' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '2504' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '2504' AND `is_public` = '1' LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '2504' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable' doesn't exist] SELECT `id` FROM `wp_yoast_indexable` WHERE `object_type` = 'post' AND `object_sub_type` IN ('post') AND `author_id` = '2504' AND `is_public` IS NULL LIMIT 1
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable_hierarchy' doesn't exist] SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC
WordPress database error: [Table 'ykbsawjebk.wp_yoast_indexable_hierarchy' doesn't exist] SELECT `ancestor_id` FROM `wp_yoast_indexable_hierarchy` WHERE `indexable_id` = '0' ORDER BY `depth` DESC
For aquariums, bird baths, rain barrels and other small water features between 1 – 50,000 gallons
Water Feature Calculator
For best results, do not undertreat your water feature.
You cannot overtreat any water feature with our all-natural products. Click on one of the buttons below that matches your water feature size. Then choose the specific range your water feature falls into. You can then click on the image to learn more about the product, see size options and choose your quantity. Or click the ‘Add to Cart’ button and add the item directly to your cart. Quantities can be adjusted in your cart as well.
What size category does your water feature fall into?